SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'fa6735398ed0be0a4bbbc6e72a14e11c3ba82004a563ce3b14e13d24b4a707af' 
  AND token = 'zKnLSIcJ0nE4mnOX9MUYUE+IYWhDQ75JuFdEVT9M+28=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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