UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VFoCrAq+dHJT6xWMajSUYuWQ4bjNoFdM6NGXoD/JOG8='
WHERE
key_id = '2a3afc944c7e4145a19eca48b2de76c33a6f6bf4ab0eaa7c9fc0f4b94355bbb4'
AND (
token = 'VFoCrAq+dHJT6xWMajSUYuWQ4bjNoFdM6NGXoD/JOG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)