UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DS2RRzWkrtVa8EdMw/BCVeESbJVWOaszh3Oifp8I3F0='
WHERE
key_id = 'c02bbbd6b1b26ac4e67d96de83907e50c040013426954bfc20756e44d94e0252'
AND (
token = 'DS2RRzWkrtVa8EdMw/BCVeESbJVWOaszh3Oifp8I3F0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)