UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LK3LFMhnQvLYCj4qYceLY0LQDMplRy0pA/5WrjkaeDo='
WHERE
key_id = '1c2b03f4f12b4cde255cf2f5be99736e8d62c0f04fd5e356867de68efca264a0'
AND (
token = 'LK3LFMhnQvLYCj4qYceLY0LQDMplRy0pA/5WrjkaeDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)