UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HuF3wTSttA57Iop31DPK7Vy9gQqobjMgFf03bDz/9OA='
WHERE
key_id = 'b9be0894e238d3759bfa792a35cca9019af87a8ae85efe7c401b0c2ab5736c8d'
AND (
token = 'HuF3wTSttA57Iop31DPK7Vy9gQqobjMgFf03bDz/9OA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)