UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afFYC7etBTRSCaIqNcU4d0KiQdCp8JWWgFOoTHGMJNc='
WHERE
key_id = '8ce08edd9d0ffd4101b47dd8f72115263a5f7d559a5d478edba682981cd62ccf'
AND (
token = 'afFYC7etBTRSCaIqNcU4d0KiQdCp8JWWgFOoTHGMJNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)