UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L4d6E+x7bFDJfzzoGHU9EuEgdRjD9ALnLQvFfW4iPzA='
WHERE
key_id = '0fc8dbe1b32ad0c770c906aa942bf22a879016c242d3dc7689da4dbeb4b0e765'
AND (
token = 'L4d6E+x7bFDJfzzoGHU9EuEgdRjD9ALnLQvFfW4iPzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)