SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f882eac28f28d9f5bf64383fbc52cde7eb5e1ad18d087f80860e0baa51355558' 
  AND token = 'oNnSFVkA/nI0n5j6OsRfbTYybV21rR/tm+zr/lTKvqs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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