UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59mk727R4XgFSEjWxih4Urh94Z4Wxcza2cHarOXHgt4='
WHERE
key_id = 'c1b0450fef652f033f7d8e909d32c8813c677ba8027fe1a67b986425830671ec'
AND (
token = '59mk727R4XgFSEjWxih4Urh94Z4Wxcza2cHarOXHgt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)