UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfBIYnLaj8ZdcbY9jP8Mor1gOzFoNzCpI9zTqNnXb9k='
WHERE
key_id = 'b492018332aaab6ce0d81656f315f7e90df78e6ce3bd1d7bd085c51748ad1718'
AND (
token = 'dfBIYnLaj8ZdcbY9jP8Mor1gOzFoNzCpI9zTqNnXb9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)