UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YBKiQ9zRNHgo4MWjyUWUxJ0QkzqXgIvZY9Ok2wXbIZE='
WHERE
key_id = '0dd796a7ebe4bd27bd3c74804fc27a3a73cbe30d5aeb996b83187e1a8c0ed065'
AND (
token = 'YBKiQ9zRNHgo4MWjyUWUxJ0QkzqXgIvZY9Ok2wXbIZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)