UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2PSu4iSg1+7YaX2li5MdFuAiahKMBkCoyuhdddkptY='
WHERE
key_id = '0e83fd862864c299017d95f6d3ccb6aa2bbd29793792836dfca8fcc1d1005ba2'
AND (
token = 'd2PSu4iSg1+7YaX2li5MdFuAiahKMBkCoyuhdddkptY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)