UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aIt7xNqOdrYO/7eQLcURYJB0tHjeodGv/6EEf6CYGyY='
WHERE
key_id = 'cc7941ef4d1c446c01d644a92f5bc792798e2f0af66756cb7ef7bda1bb09697f'
AND (
token = 'aIt7xNqOdrYO/7eQLcURYJB0tHjeodGv/6EEf6CYGyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)