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