UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0K7H8oCJ09lDk9lADZlrni9+tA23HVobWr6m4oKVZGw='
WHERE
key_id = 'db82317b4a142aec483d2beddf42740ae0baa822a9fc1571d7a4cf142b6130be'
AND (
token = '0K7H8oCJ09lDk9lADZlrni9+tA23HVobWr6m4oKVZGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)