UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IXo93s3oL8F3bxA4lUV/q0m+sjgbVCH2xchr0iZJzRM=' 
WHERE 
  key_id = '089af7fd5e87290e6b1e70c4688a14849fc54a0904196ac6533a393d318bd867' 
  AND (
    token = 'IXo93s3oL8F3bxA4lUV/q0m+sjgbVCH2xchr0iZJzRM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032