SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '986a97ac2e389fb713890ea4c80bc28028646ac73d86637c1cfd556b4d9dffc0' 
  AND token = 'GKB9Qu5REcrk8GxOsxkD901aZh0B3GdmQT9qZ6jyWXI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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