SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '288a31a72192fed7abd0a6cce0dc616cbc435d471cf5448ee9e55c470230591c' 
  AND token = 'i8yCH5I2kfbb6l9IdBehXfdYi+3iKfnBjuzSX3srh94=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}