UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '58mW6vnlxE0N2OT640MTzhkPpqbbzL/f24LOauwuiko='
WHERE
key_id = '966e049b213010a214690c837140c68c6be05c12eb998771cc97ada82982c1c9'
AND (
token = '58mW6vnlxE0N2OT640MTzhkPpqbbzL/f24LOauwuiko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)