UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cDdTg89S+ZG6xd3uV2R5R+nl0Xp2wO0312+N8Ca6tMc='
WHERE
key_id = 'cf8c4e051c226c8ab497be24d8ea7b7a49e9734119a997e730d594021403bd10'
AND (
token = 'cDdTg89S+ZG6xd3uV2R5R+nl0Xp2wO0312+N8Ca6tMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)