UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jL8vGfdaJf5A99QpFLFpvgRT2+0Cx5FC5bZoSf/0hd8='
WHERE
key_id = '1df2194950301f661754d89c8691f64e7f85b7aa49f432d7acc2dd856e0d2bff'
AND (
token = 'jL8vGfdaJf5A99QpFLFpvgRT2+0Cx5FC5bZoSf/0hd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)