UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ka/ZcQhAcfI3gylMUKvyeHv0dKLwr4ol2Bfew2ntrr4='
WHERE
key_id = 'e3f9a82a6e07e2a861a817bd3148d0d0ce00fe6ffd8f26d493be144f20de0fa0'
AND (
token = 'ka/ZcQhAcfI3gylMUKvyeHv0dKLwr4ol2Bfew2ntrr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)