UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmFsiWf2Y60L/LScfGtm+pyVgKE+2enLM2NuI9W8dWE='
WHERE
key_id = 'b504fafc39b76b3cc257f520382c75d0be68954bc42d18157018fd0d8b7801e9'
AND (
token = 'CmFsiWf2Y60L/LScfGtm+pyVgKE+2enLM2NuI9W8dWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)