SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2ab6a235f05a2960f3aaa48a2e4ca6f2528c9b9a51541c8350d202eee4e491b7' 
  AND token = 'x+xaTqyn42sT8nkWUJ6XEQiqV5gxcJBmr5W1Pv4s9k8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00033

JSON explain

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