UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cxR+JEnjRy9Q1t63V8/RRHI3gx8SeBMkfjLyx4WNP+s='
WHERE
key_id = '7c640f876223d3e821b46a7a2495036452f27e1e0380e289a2ed626a6402e564'
AND (
token = 'cxR+JEnjRy9Q1t63V8/RRHI3gx8SeBMkfjLyx4WNP+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)