UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccDrkviW8B9V84KMpKP0NBR4hBcUfaWiCNip+aVoFw0='
WHERE
key_id = 'bd2b7ae6dfea8bfdda2b535ecdaede56dd85de7e78050cadd893353793a6001f'
AND (
token = 'ccDrkviW8B9V84KMpKP0NBR4hBcUfaWiCNip+aVoFw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)