SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '548a403a0b33476fd06df0833483b6a9ac92c20635c2d70e9732ab84643c1984' 
  AND token = 'VRHRvRQS55LaXfXvZV0mcbKhymvfZ/xyR4o99Q2e0ns=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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