UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aIkzPP4mAvlgVTAn2BVcswfT3YMK/HWZO4fH5V/RwD0='
WHERE
key_id = 'a9973d8e29d0324e35a8b4c299500eb99ec3c29ae204de01b683adf12f803ebf'
AND (
token = 'aIkzPP4mAvlgVTAn2BVcswfT3YMK/HWZO4fH5V/RwD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)