UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTvESyVbsr3zugSOBNTTDahl9SRom48vfko2toBGAzY='
WHERE
key_id = '9a69d2f94e5189bd17d02c2bc88db39462f1027b16a770a17e5c335495fd8b72'
AND (
token = 'HTvESyVbsr3zugSOBNTTDahl9SRom48vfko2toBGAzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)