UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPJOOg8i6H1QmVe3eYSV/Bg7f4xq21ExNThbpOGvcas='
WHERE
key_id = '99e10077a20100e5a23ae094e765f2b33b977aea6e5d6e6061e49c6dc685d171'
AND (
token = 'hPJOOg8i6H1QmVe3eYSV/Bg7f4xq21ExNThbpOGvcas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)