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