UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZzDuRn6+Ikp4ir428RFMMHsIkpfGAnjT3eOlQhKIfQ='
WHERE
key_id = '4b11309417e622b028541f46ef2e00431053eb0c03ae8c048c1c961d4b957409'
AND (
token = 'pZzDuRn6+Ikp4ir428RFMMHsIkpfGAnjT3eOlQhKIfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)