UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G86e1JtNB02bEEyzGpfgZIUbZuEvbl3LjDJeZb5yZ4='
WHERE
key_id = '794dc06c4ad5b46613833dea7251bd353577d480a40ed8d94159693fa1665a8d'
AND (
token = '1G86e1JtNB02bEEyzGpfgZIUbZuEvbl3LjDJeZb5yZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)