UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e16LTRwHTp6EbEv8LGa04AAH26TCdOaDuZ+yaNmg+hM='
WHERE
key_id = 'c5351e0bbc03409cb91d1473c30b04f8806f62e7a8a758c2d9b89f9d5d05294b'
AND (
token = 'e16LTRwHTp6EbEv8LGa04AAH26TCdOaDuZ+yaNmg+hM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)