UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yOO0Q5kkyHMW8wopZQ1TSKAy2RUDBhDjmPGXYXP16QU='
WHERE
key_id = 'ce9f3df65ce023de7eae8464407c2e67f4e5ee8580b108520e5b2e49e817bca0'
AND (
token = 'yOO0Q5kkyHMW8wopZQ1TSKAy2RUDBhDjmPGXYXP16QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)