UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JEVt3hlqKxGhqXKVWuT7XkFdKTRbK2yoGzkSwiz3Wnc=' 
WHERE 
  key_id = '6036d5b03733674ca85a5173c6507094d34b0cadb14e6040e8d2d2d4cbcaa911' 
  AND (
    token = 'JEVt3hlqKxGhqXKVWuT7XkFdKTRbK2yoGzkSwiz3Wnc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035