UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Htdk8IDzeleWmofXSyyAGkB9uvkZ6hSqU+53tuWSrI4='
WHERE
key_id = 'cc04cc0485ca665d70e30dafc44392e605521262536f2be32c48ef9f5c569b96'
AND (
token = 'Htdk8IDzeleWmofXSyyAGkB9uvkZ6hSqU+53tuWSrI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)