UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNd9E5ItcPegt6XyAYKdYjdhk1nyQl+cvu0tOUpkhlk='
WHERE
key_id = '0bf27c85ecdbb17a42ab33aff2d01d31674c21095ac7f65762449ced386e98c2'
AND (
token = 'KNd9E5ItcPegt6XyAYKdYjdhk1nyQl+cvu0tOUpkhlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)