UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzPTpGbPtQ7gfxA4tIpORvx8yHouaK2sUBLejBb02UA='
WHERE
key_id = 'b39968560e5f7d711fc60393e601f2345c746bf93c8d0db110360c696f74936a'
AND (
token = 'xzPTpGbPtQ7gfxA4tIpORvx8yHouaK2sUBLejBb02UA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)