UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8KFsGWcxEM83tUy4N5WsCOIzx8PqFeDlM198tO4SU4='
WHERE
key_id = '24cbb1978d502dcaed42f39659975ba2a462978ca8115342d99432a4eb3ca187'
AND (
token = 'q8KFsGWcxEM83tUy4N5WsCOIzx8PqFeDlM198tO4SU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)