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