UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lk58XoMb1wV2kN2o5EdYWl2ricHe1F3kElEWZuPYw2k='
WHERE
key_id = '8fd16befddfc63ec2749d5cb551837d1b87e9c347123b811205fd52f912f78e0'
AND (
token = 'Lk58XoMb1wV2kN2o5EdYWl2ricHe1F3kElEWZuPYw2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)