UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'liKzNT1n2ZiYXtvhgbzoYV5Dp6fMK9DFx6K/kH3C7BI='
WHERE
key_id = 'f529cfe97ce7d200c1ba13ffd1d3844c3ca29d41b0f7885165911a64caf4d340'
AND (
token = 'liKzNT1n2ZiYXtvhgbzoYV5Dp6fMK9DFx6K/kH3C7BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)