SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8c31d3e9ec27a45eeb2b0595e03dcad89b1dc43ee0bd552f27677519fc24e73d' 
  AND token = 'wQM3F1E5Lo1/Iaze/zPjqmAwkbI1gSy9p0pS10o43OY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}