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