UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PLrYRPgIJBqTXky7Xmx7V/tMA0Y9TNb8cBl3EpoIcig='
WHERE
key_id = 'c3cd38ff0cdee42eadd41b82f2b27af8dcc4460122fd4e41298bc40b9c77ce13'
AND (
token = 'PLrYRPgIJBqTXky7Xmx7V/tMA0Y9TNb8cBl3EpoIcig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)