UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9BmTnVQbiPi32L5oz2/UgvB3+uT+AUqp/U0vMv3VgI='
WHERE
key_id = 'e2ce9f2005b5898f6cd3c7fe385ee294119720069eaf6ba3101670b511d08cdc'
AND (
token = 'J9BmTnVQbiPi32L5oz2/UgvB3+uT+AUqp/U0vMv3VgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)